﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'puestoGet')
	BEGIN
		DROP  Procedure  puestoGet
	END
GO

CREATE PROCEDURE [dbo].[puestoGet] 	
	(	
		@empresa_id AS INT		
	)	
AS
BEGIN	
	SET NOCOUNT ON
	  
	SELECT Id, EmpresaId, Nombre
	FROM Lit_Puesto
	WHERE EmpresaId = @empresa_id
	AND Activo = 1
	  
	SET NOCOUNT OFF
END
GO